package com.example.demo.mapper;

import com.example.demo.entity.Jshop_goods;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 商品表 Mapper 接口
 * </p>
 *
 * @author Fyly
 * @since 2019-04-12
 */
@Repository
@Mapper
public interface Jshop_goodsMapper extends BaseMapper<Jshop_goods> {

    @Select({"select id, name, price, costprice, fabs_price, image_id from Jshop_goods where goods_type_id = #{typeid}"})
    List<Jshop_goods> selectListBytype(Integer typeid);

}
